﻿CREATE TABLE [dbo].[TimeBooking] (
    [Year]                 INT             NULL,
    [MonthName]            VARCHAR (7)     NULL,
    [ResourceSoeid]        VARCHAR (255)   NULL,
    [ResourceName]         VARCHAR (200)   NULL,
    [ResourceType]         VARCHAR (255)   NULL,
    [ResourceManagerName]  VARCHAR (200)   NULL,
    [ProjectNonProject]    VARCHAR (50)    NULL,
    [ProjectId]            VARCHAR (10)    NULL,
    [ProjectManager]       VARCHAR (300)   NULL,
    [SystemGOCCode]        VARCHAR (15)    NULL,
    [SystemManGeoTreeNode] VARCHAR (10)    NULL,
    [SystemMSNodeName3]    VARCHAR (300)   NULL,
    [SystemMSNodeName4]    VARCHAR (300)   NULL,
    [SystemMSNodeName5]    VARCHAR (300)   NULL,
    [SystemMSNodeName6]    VARCHAR (300)   NULL,
    [SystemMSNodeName7]    VARCHAR (300)   NULL,
    [SystemMSNodeName8]    VARCHAR (300)   NULL,
    [SystemMSNodeName9]    VARCHAR (300)   NULL,
    [SystemMSNodeName10]   VARCHAR (300)   NULL,
    [ClientGOCId]          VARCHAR (15)    NULL,
    [ClientManGeoTreeNode] VARCHAR (10)    NULL,
    [ClientMSNodeName3]    VARCHAR (300)   NULL,
    [ClientMSNodeName4]    VARCHAR (300)   NULL,
    [ClientMSNodeName5]    VARCHAR (300)   NULL,
    [ClientMSNodeName6]    VARCHAR (300)   NULL,
    [ClientMSNodeName7]    VARCHAR (300)   NULL,
    [ClientMSNodeName8]    VARCHAR (300)   NULL,
    [ClientMSNodeName9]    VARCHAR (300)   NULL,
    [ClientMSNodeName10]   VARCHAR (300)   NULL,
    [ClientPercentage]     DECIMAL (10, 3) NULL,
    [MinHrsPerWeek]        INT             NULL,
    [TimesheetStatus]      VARCHAR (100)   NULL,
    [WeekStart]            DATETIME        NULL,
    [WeekEnd]              DATETIME        NULL,
    [TotalHours]           DECIMAL (10, 3) NULL,
    [Month]                CHAR (2)        NULL,
    FOREIGN KEY ([ProjectId]) REFERENCES [dbo].[Project] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION
);





